COVID-19 Interactive Analysis Dashboard

In [1]:
# importing libraries

from __future__ import print_function
from ipywidgets import interact, interactive, fixed, interact_manual
from IPython.core.display import display, HTML

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import plotly.express as px
import folium
import plotly.graph_objects as go
import seaborn as sns
import ipywidgets as widgets
In [2]:
# loading data right from the source:
death_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv')
confirmed_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv')
recovered_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv')
country_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/web-data/data/cases_country.csv')
In [3]:
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)


confirmeddf=confirmed_df[confirmed_df.columns[1:2]]
confirmeddf=pd.concat([confirmeddf,confirmed_df[confirmed_df.columns[-7:]]],axis=1)
confirmeddf.head(313)
Out[3]:
Country/Region 12/18/20 12/19/20 12/20/20 12/21/20 12/22/20 12/23/20 12/24/20
0 Afghanistan 49621 49681 49817 50013 50190 50433 50655
1 Albania 52004 52542 53003 53425 53814 54317 54827
2 Algeria 94371 94781 95203 95659 96069 96549 97007
3 Andorra 7519 7560 7577 7602 7633 7669 7699
4 Angola 16562 16626 16644 16686 16802 16931 17029
5 Antigua and Barbuda 152 152 153 153 153 154 154
6 Argentina 1531374 1537169 1541285 1547138 1555279 1563865 1563865
7 Armenia 152253 153173 153825 154065 154602 155440 156142
8 Australia 117 117 118 118 118 118 118
9 Australia 4712 4748 4771 4789 4805 4823 4832
10 Australia 69 71 71 71 71 73 73
11 Australia 1232 1234 1235 1235 1236 1238 1240
12 Australia 563 563 566 566 566 568 568
13 Australia 234 234 234 234 234 234 234
14 Australia 20354 20356 20357 20360 20361 20361 20361
15 Australia 845 845 846 846 846 847 848
16 Austria 334913 337209 338854 340373 342226 344357 347204
17 Azerbaijan 195422 199127 202088 203593 205877 208211 210061
18 Bahamas 7733 7733 7746 7765 7772 7788 7788
19 Bahrain 89883 90062 90282 90450 90634 90817 91070
20 Bangladesh 498293 499560 500713 502183 503501 504868 506102
21 Barbados 307 307 307 321 327 329 345
22 Belarus 169648 171579 173523 175416 177274 179196 181113
23 Belgium 621039 623760 625930 626911 629109 632321 634904
24 Belize 9791 9791 9791 10145 10257 10370 10490
25 Benin 3152 3152 3167 3167 3167 3205 3205
26 Bhutan 443 443 446 479 479 519 519
27 Bolivia 149149 149770 150023 150385 151059 152064 153121
28 Bosnia and Herzegovina 104881 105524 105524 106222 106986 107570 108298
29 Botswana 13014 13014 13014 13622 13622 13622 14025
30 Brazil 7162978 7213155 7238600 7263619 7318821 7365517 7423945
31 Brunei 152 152 152 152 152 152 152
32 Bulgaria 190027 191029 191195 192472 194271 195886 196658
33 Burkina Faso 4832 4954 5160 5301 5461 5649 5941
34 Burma 114198 115187 116134 116982 117946 118869 119788
35 Burundi 751 761 761 762 762 773 773
36 Cabo Verde 11526 11567 11579 11600 11636 11668 11688
37 Cambodia 362 362 363 363 363 363 363
38 Cameroon 25472 25724 25849 25849 25849 25849 26277
39 Canada 87581 88933 90219 91459 92480 93781 93781
40 Canada 45400 45400 45400 47067 47510 48027 48609
41 Canada 0 0 0 0 0 0 0
42 Canada 13 13 13 13 13 13 13
43 Canada 22397 22630 22859 23025 23180 23381 23624
44 Canada 573 578 574 578 580 585 587
45 Canada 372 380 382 382 383 384 384
46 Canada 24 24 24 24 24 24 24
47 Canada 1443 1445 1445 1447 1454 1458 1465
48 Canada 259 259 259 262 262 264 265
49 Canada 155180 157749 159871 162052 164318 166802 169137
50 Canada 90 90 90 90 91 91 94
51 Canada 172801 174839 176985 179093 181276 183523 185872
52 Canada 13 13 13 13 13 13 13
53 Canada 13077 13329 13555 13761 13942 14101 14255
54 Canada 59 59 59 59 59 59 60
55 Central African Republic 4936 4936 4936 4936 4936 4948 4948
56 Chad 1839 1867 1890 1902 1916 1938 1958
57 Chile 581135 583355 585546 587993 589189 590914 594152
58 China 992 992 992 992 992 992 992
59 China 959 961 961 961 961 961 961
60 China 590 590 590 590 590 590 590
61 China 504 505 507 507 507 507 507
62 China 182 182 182 182 182 182 182
63 China 2027 2028 2031 2034 2035 2036 2037
64 China 264 264 264 264 264 264 264
65 China 147 147 147 147 147 147 147
66 China 171 171 171 171 171 171 171
67 China 373 373 373 373 373 373 373
68 China 960 960 961 961 961 961 961
69 China 1296 1297 1297 1297 1297 1298 1298
70 China 7969 8078 8152 8237 8300 8353 8424
71 China 68149 68149 68149 68149 68149 68149 68149
72 China 1020 1020 1020 1020 1020 1020 1020
73 China 342 344 350 352 352 352 352
74 China 684 684 684 684 684 684 684
75 China 935 935 935 935 935 935 935
76 China 157 157 157 157 157 157 157
77 China 290 291 292 294 295 302 310
78 China 46 46 46 46 46 46 46
79 China 75 75 75 75 75 75 75
80 China 18 18 18 18 18 18 18
81 China 502 504 504 504 504 504 504
82 China 861 861 861 861 861 861 861
83 China 1436 1447 1455 1461 1473 1479 1483
84 China 223 223 224 224 224 224 224
85 China 839 840 841 843 843 845 846
86 China 304 304 304 304 304 304 304
87 China 1 1 1 1 1 1 1
88 China 980 980 980 980 980 980 980
89 China 227 227 227 227 227 227 227
90 China 1298 1299 1299 1299 1300 1300 1300
91 Colombia 1482072 1496062 1507222 1518067 1530593 1544826 1559766
92 Comoros 643 643 666 666 693 693 715
93 Congo (Brazzaville) 6200 6200 6200 6200 6571 6571 6571
94 Congo (Kinshasa) 15089 15397 15495 15669 15810 16039 16282
95 Costa Rica 157472 157472 157472 159893 160804 161942 162990
96 Cote d'Ivoire 21845 21890 21918 21932 21942 21984 22071
97 Croatia 190235 192987 194962 195728 197323 200086 202319
98 Cuba 9893 10024 10127 10242 10384 10500 10717
99 Cyprus 16647 17476 17688 18004 18004 18883 19316
100 Czechia 610006 618836 624140 627523 635414 646312 660461
101 Denmark 534 539 546 547 550 556 561
102 Denmark 19 19 19 25 25 25 25
103 Denmark 128321 131606 134434 137632 140175 143472 146341
104 Diamond Princess 712 712 712 712 712 712 712
105 Djibouti 5780 5781 5781 5783 5786 5789 5800
106 Dominica 88 88 88 88 88 88 88
107 Dominican Republic 157929 159064 160386 161052 161930 162496 163654
108 Ecuador 205003 205920 206257 206329 206364 207084 208010
109 Egypt 124280 124891 125555 126273 127061 127972 128993
110 El Salvador 42397 43195 43477 43772 43772 43772 44619
111 Equatorial Guinea 5214 5214 5214 5231 5231 5236 5236
112 Eritrea 741 754 754 807 832 877 951
113 Estonia 20658 21219 21794 22083 22647 23309 24009
114 Eswatini 7202 7305 7427 7562 7715 7868 8032
115 Ethiopia 119025 119494 119951 120348 120638 120989 121399
116 Fiji 46 46 46 46 46 46 46
117 Finland 32582 32853 33162 33414 33717 34084 34447
118 France 12163 12281 12369 12369 12433 12499 12547
119 France 16182 16182 16182 16345 16410 16466 16550
120 France 8498 8498 8557 8557 8557 8557 8557
121 France 5601 5601 5634 5634 5634 5634 5634
122 France 5616 5708 5708 5708 5708 5767 5767
123 France 37 37 37 37 38 38 38
124 France 8588 8704 8704 8704 8801 8801 8846
125 France 175 175 175 175 175 184 184
126 France 14 14 14 14 14 15 15
127 France 918 918 918 918 918 961 961
128 France 2441737 2458839 2471458 2477255 2488889 2503693 2525234
129 Gabon 9400 9400 9400 9420 9420 9469 9469
130 Gambia 3786 3786 3786 3786 3791 3791 3791
131 Georgia 204003 206907 208638 209462 212526 214871 216843
132 Germany 1486839 1508518 1514962 1534218 1570371 1604129 1630596
133 Ghana 53653 53653 53653 53954 53954 54043 54043
134 Greece 129584 130485 131072 131597 132430 133365 134235
135 Grenada 94 94 103 103 103 105 105
136 Guatemala 132062 132595 132765 132867 133601 134256 134894
137 Guinea 13511 13532 13545 13578 13578 13598 13630
138 Guinea-Bissau 2447 2447 2447 2447 2447 2447 2447
139 Guyana 6076 6105 6125 6171 6216 6258 6266
140 Haiti 9648 9674 9674 9763 9771 9805 9805
141 Holy See 27 27 27 27 27 27 27
142 Honduras 116212 116212 117022 117190 117588 118036 118036
143 Hungary 295977 300022 302989 305130 306368 308262 311554
144 Iceland 5604 5621 5642 5656 5667 5683 5683
145 India 10004599 10031223 10055560 10075116 10099066 10123778 10146845
146 Indonesia 650197 657948 664930 671778 678125 685639 692838
147 Iran 1145651 1152072 1158384 1164535 1170743 1177004 1183182
148 Iraq 581811 583118 584145 585345 586503 587676 588803
149 Ireland 78254 78776 79542 80267 81228 82155 83073
150 Israel 370152 372886 374760 378259 382487 385022 389678
151 Italy 1921778 1938083 1953185 1964054 1977370 1991278 2009317
152 Jamaica 12039 12135 12224 12289 12354 12423 12519
153 Japan 193753 196815 199270 201074 203732 207007 210769
154 Jordan 271514 272797 274949 277448 279892 281983 283690
155 Kazakhstan 190292 190969 191650 192579 193503 194257 194993
156 Kenya 93761 94151 94500 94614 94768 95195 95431
157 Korea, South 48570 49665 50591 51460 52550 53533 54770
158 Kosovo 48337 48682 48905 49169 49169 49440 49440
159 Kuwait 147531 147775 147979 148209 148507 148773 149017
160 Kyrgyzstan 78679 78911 79254 79254 79429 79659 79845
161 Laos 41 41 41 41 41 41 41
162 Latvia 29427 30297 30940 31335 32339 33484 34754
163 Lebanon 154944 156570 158104 159286 160979 163225 165933
164 Lesotho 2546 2546 2546 2546 2546 2725 2725
165 Liberia 1779 1779 1779 1779 1779 1779 1779
166 Libya 93772 93772 94560 95200 95706 96346 97192
167 Liechtenstein 1676 1711 1758 1784 1826 1858 1920
168 Lithuania 106210 109429 112359 114487 116358 120094 123889
169 Luxembourg 43728 43728 43728 44582 44809 45209 45209
170 MS Zaandam 9 9 9 9 9 9 9
171 Madagascar 17587 17587 17633 17633 17633 17633 17633
172 Malawi 6148 6153 6161 6202 6248 6261 6277
173 Malaysia 90816 91969 93309 95327 97389 98737 100318
174 Maldives 13444 13474 13493 13501 13524 13537 13558
175 Mali 6120 6164 6191 6232 6291 6347 6441
176 Malta 11569 11621 11714 11802 11910 11992 12062
177 Marshall Islands 4 4 4 4 4 4 4
178 Mauritania 12046 12278 12418 12567 12745 12944 13118
179 Mauritius 524 524 524 524 526 527 527
180 Mexico 1301546 1313675 1320545 1325915 1338426 1350079 1362564
181 Moldova 133360 134578 135207 135910 136931 138213 139435
182 Monaco 715 723 728 742 756 767 783
183 Mongolia 953 961 993 1006 1063 1069 1075
184 Montenegro 43390 43709 43955 44284 44542 45062 45423
185 Morocco 412393 415226 417125 418002 420648 423214 425864
186 Mozambique 17338 17477 17568 17695 17767 17767 18031
187 Namibia 18041 18437 18714 19299 19629 19984 20579
188 Nepal 252474 253184 253772 254514 255236 255979 256592
189 Netherlands 5138 5155 5163 5176 5199 5228 5257
190 Netherlands 177 179 179 179 179 182 182
191 Netherlands 3881 3920 3947 3974 4006 4051 4099
192 Netherlands 1315 1323 1328 1338 1362 1370 1385
193 Netherlands 664456 676673 689705 700873 710683 721071 732570
194 New Zealand 2110 2116 2121 2121 2128 2128 2128
195 Nicaragua 5938 5938 5938 5938 5938 5991 5991
196 Niger 2560 2612 2659 2724 2803 2876 2933
197 Nigeria 77013 77933 78434 78790 79789 80922 81963
198 North Macedonia 77134 77949 78305 78434 79190 79815 80407
199 Norway 43207 43582 43905 44336 44932 45455 45931
200 Oman 127019 127019 127667 127931 128143 128236 128290
201 Pakistan 454673 457288 458968 460672 462814 465070 467222
202 Panama 206310 209584 212339 214038 217202 220261 223674
203 Papua New Guinea 760 760 760 761 761 761 780
204 Paraguay 98296 99157 99789 100612 101544 102371 103329
205 Peru 989457 989457 995899 997517 998475 1000153 1000153
206 Philippines 456562 458044 459789 461505 462815 464004 465724
207 Poland 1182864 1194110 1202700 1207333 1214525 1226883 1239998
208 Portugal 366952 370787 374121 376220 378656 383258 387636
209 Qatar 141716 141858 142001 142159 142308 142448 142605
210 Romania 582786 587944 591294 593783 598792 604251 608561
211 Russia 2764843 2792615 2821125 2850042 2878382 2905196 2934695
212 Rwanda 7105 7232 7293 7402 7511 7598 7670
213 Saint Kitts and Nevis 30 30 30 30 30 30 30
214 Saint Lucia 280 282 287 287 303 305 305
215 Saint Vincent and the Grenadines 100 100 104 104 107 108 108
216 Samoa 2 2 2 2 2 2 2
217 San Marino 2072 2107 2107 2135 2176 2205 2231
218 Sao Tome and Principe 1011 1012 1012 1012 1012 1012 1012
219 Saudi Arabia 360690 360848 361010 361178 361359 361536 361725
220 Senegal 17559 17670 17758 17879 17945 18043 18200
221 Serbia 292640 296528 300062 303747 307827 312253 316344
222 Seychelles 202 202 202 205 205 205 205
223 Sierra Leone 2486 2497 2509 2509 2518 2524 2531
224 Singapore 58386 58403 58422 58432 58461 58482 58495
225 Slovakia 146124 149275 151336 152555 155218 158905 161562
226 Slovenia 103555 105013 105899 106294 107805 109934 112021
227 Solomon Islands 17 17 17 17 17 17 17
228 Somalia 4662 4662 4662 4662 4690 4690 4690
229 South Africa 901538 912477 921922 930711 940212 954258 968563
230 South Sudan 3228 3228 3228 3234 3234 3455 3455
231 Spain 1797236 1797236 1797236 1819249 1829903 1842289 1854951
232 Sri Lanka 36049 36667 37261 37631 38059 38639 39231
233 Sudan 22265 22621 22823 22963 23316 23316 23316
234 Suriname 5459 5511 5552 5583 5669 5734 5810
235 Sweden 367120 367120 367120 367120 389439 396048 396048
236 Switzerland 403989 403989 403989 413991 418266 423299 428197
237 Syria 9928 10050 10195 10318 10442 10571 10701
238 Taiwan* 759 763 766 766 770 776 776
239 Tajikistan 12888 12923 12960 12998 13034 13071 13106
240 Tanzania 509 509 509 509 509 509 509
241 Thailand 4331 4907 4907 5716 5716 5762 5910
242 Timor-Leste 31 31 31 31 31 33 41
243 Togo 3350 3396 3416 3436 3467 3494 3520
244 Trinidad and Tobago 6955 6974 7000 7012 7024 7071 7089
245 Tunisia 117582 119151 120687 121718 123323 125000 126752
246 Turkey 1982090 2004285 2024601 2043704 2062960 2082610 2100712
247 US 17459296 17655591 17844690 18035209 18230242 18458373 18650454
248 Uganda 30071 30702 31187 31384 31910 32399 32914
249 Ukraine 970758 982937 991700 998678 1007627 1018199 1030125
250 United Arab Emirates 191150 192404 193575 194652 195878 197124 198435
251 United Kingdom 10 10 10 10 11 11 11
252 United Kingdom 497 516 527 527 553 553 560
253 United Kingdom 80 86 86 86 86 86 86
254 United Kingdom 311 311 311 316 316 317 318
255 United Kingdom 2389 2526 2629 2738 2776 2857 2880
256 United Kingdom 23 23 23 23 29 29 29
257 United Kingdom 1184 1211 1244 1282 1330 1398 1476
258 United Kingdom 373 373 373 374 374 374 374
259 United Kingdom 13 13 13 13 13 13 13
260 United Kingdom 781 789 798 798 807 807 810
261 United Kingdom 1977167 2004219 2040147 2073511 2110314 2149551 2188587
262 Uruguay 11950 12557 13048 13477 14001 14710 15457
263 Uzbekistan 75675 75806 75933 76048 76180 76315 76456
264 Vanuatu 1 1 1 1 1 1 1
265 Venezuela 109395 109781 110075 110513 110828 111024 111245
266 Vietnam 1410 1411 1413 1414 1420 1421 1432
267 West Bank and Gaza 119612 121216 122643 123945 125506 127376 129080
268 Yemen 2087 2087 2087 2087 2087 2087 2092
269 Zambia 18575 18620 18716 18768 18881 19122 19234
270 Zimbabwe 12047 12151 12325 12422 12544 12656 12786
In [4]:
recovereddf=recovered_df[recovered_df.columns[1:2]]
recovereddf=pd.concat([recovereddf,recovered_df[recovered_df.columns[-7:]]],axis=1)
recovereddf.head(313)
Out[4]:
Country/Region 12/18/20 12/19/20 12/20/20 12/21/20 12/22/20 12/23/20 12/24/20
0 Afghanistan 38540 38613 39006 39508 39585 39692 40359
1 Albania 27426 27831 28121 28752 29249 29799 30276
2 Algeria 62487 62869 63260 63644 64020 64401 64777
3 Andorra 6919 6963 6997 7028 7073 7106 7171
4 Angola 9345 9518 9592 9695 9729 9729 9729
5 Antigua and Barbuda 141 141 143 143 144 146 146
6 Argentina 1356755 1362617 1368346 1374401 1379726 1384277 1384277
7 Armenia 131213 131931 132532 133176 134586 135638 136766
8 Australia 114 114 114 114 114 114 114
9 Australia 3192 3192 3192 3192 3192 3192 3192
10 Australia 59 59 59 62 62 62 62
11 Australia 1214 1214 1214 1215 1215 1216 1216
12 Australia 559 559 559 559 559 560 560
13 Australia 217 217 221 221 221 221 221
14 Australia 19524 19524 19524 19526 19527 19527 19527
15 Australia 821 825 826 827 828 830 832
16 Austria 297424 300611 303213 305658 309595 312921 315952
17 Azerbaijan 131252 135462 139779 142807 147199 151660 155886
18 Bahamas 6109 6109 6122 6127 6166 6166 6166
19 Bahrain 88003 88178 88331 88542 88666 88826 88963
20 Bangladesh 433614 435601 437527 439694 441929 444345 446690
21 Barbados 280 280 280 281 284 290 291
22 Belarus 147316 149353 151635 152930 154807 157079 159437
23 Belgium 0 0 0 0 0 0 0
24 Belize 4779 4779 4779 8435 8802 8933 9081
25 Benin 2972 2972 3061 3061 3061 3061 3061
26 Bhutan 422 423 423 430 430 438 438
27 Bolivia 127540 127815 127969 128308 128540 129052 129387
28 Bosnia and Herzegovina 70249 70620 70620 71548 72597 73149 73896
29 Botswana 10535 10535 10535 11147 11147 11147 11627
30 Brazil 6322955 6388938 6408517 6469310 6501341 6512717 6512717
31 Brunei 148 149 149 149 149 149 149
32 Bulgaria 96622 98026 99758 102666 105090 106465 107680
33 Burkina Faso 3403 3504 3659 3758 3877 4018 4129
34 Burma 92916 94118 95387 96685 97819 99325 99927
35 Burundi 640 687 687 687 687 687 687
36 Cabo Verde 11164 11215 11248 11270 11275 11311 11366
37 Cambodia 345 345 345 347 349 349 354
38 Cameroon 23851 23851 23851 23851 23851 23851 24892
39 Canada 410988 416901 422175 429372 437458 444166 448119
40 Central African Republic 1924 1924 1924 1924 1924 1924 1924
41 Chad 1630 1632 1632 1633 1634 1638 1651
42 Chile 552289 554333 555956 557913 559845 561794 563457
43 China 986 986 986 986 986 986 986
44 China 940 940 940 940 941 941 941
45 China 584 584 584 584 584 584 584
46 China 477 478 480 482 484 485 486
47 China 180 180 180 180 180 180 180
48 China 1977 1979 1982 1982 1986 1993 1995
49 China 261 261 261 261 261 261 261
50 China 145 145 145 145 145 145 145
51 China 165 165 165 165 165 165 165
52 China 367 367 367 367 367 367 367
53 China 936 936 936 936 936 937 937
54 China 1268 1269 1269 1270 1270 1270 1270
55 China 6628 6737 6837 6910 6995 7112 7203
56 China 63637 63637 63637 63637 63637 63637 63637
57 China 1016 1016 1016 1016 1016 1016 1016
58 China 324 326 329 331 331 335 336
59 China 677 678 679 679 679 679 679
60 China 934 934 934 934 934 934 934
61 China 155 155 155 155 155 155 155
62 China 287 287 287 287 287 287 287
63 China 46 46 46 46 46 46 46
64 China 75 75 75 75 75 75 75
65 China 18 18 18 18 18 18 18
66 China 485 485 485 485 485 487 487
67 China 841 841 841 841 841 841 841
68 China 1336 1346 1351 1352 1358 1362 1367
69 China 220 220 220 220 221 221 221
70 China 798 800 801 801 804 806 807
71 China 296 296 296 297 297 298 298
72 China 1 1 1 1 1 1 1
73 China 977 977 977 977 977 977 977
74 China 211 211 211 211 211 213 213
75 China 1290 1290 1290 1290 1290 1290 1290
76 Colombia 1354021 1362543 1373332 1382340 1394374 1404168 1417316
77 Comoros 610 610 611 611 615 615 626
78 Congo (Brazzaville) 4988 4988 4988 4988 4988 4988 4988
79 Congo (Kinshasa) 13010 13310 13447 13660 13736 13736 13982
80 Costa Rica 125488 125488 125488 126777 127618 128216 128842
81 Cote d'Ivoire 21420 21451 21478 21517 21536 21573 21629
82 Croatia 165915 169768 173158 176366 178880 180735 183532
83 Cuba 8912 8976 9040 9126 9219 9307 9378
84 Cyprus 2057 2057 2057 2057 2057 2057 2057
85 Czechia 527062 531622 533307 534686 541012 546926 552444
86 Denmark 516 516 518 518 524 526 526
87 Denmark 18 19 19 19 19 19 19
88 Denmark 87560 89570 91263 93214 95933 99025 102184
89 Diamond Princess 699 699 699 699 699 699 699
90 Djibouti 5641 5649 5659 5668 5676 5681 5690
91 Dominica 83 83 83 83 83 83 83
92 Dominican Republic 122406 123284 124276 124931 125715 125965 126732
93 Ecuador 177951 177951 177951 181618 181618 181618 181618
94 Egypt 106157 106481 106817 107162 107563 107961 108474
95 El Salvador 38481 39016 39142 39362 39362 39362 39989
96 Equatorial Guinea 5064 5064 5064 5077 5077 5078 5078
97 Eritrea 572 580 580 597 599 599 600
98 Estonia 12922 13488 13590 13677 14395 14898 15393
99 Eswatini 6624 6662 6696 6761 6821 6879 6952
100 Ethiopia 100859 102153 102980 103681 104818 105824 106845
101 Fiji 42 42 42 42 44 44 44
102 Finland 22500 22500 22500 22500 22500 26000 26000
103 France 9995 9995 9995 9995 9995 9995 9995
104 France 4842 4842 4842 4842 4842 4842 4842
105 France 2242 2242 2242 2242 2242 2242 2242
106 France 98 98 98 98 98 98 98
107 France 2964 2964 2964 2964 2964 2964 2964
108 France 35 35 35 35 37 37 37
109 France 8219 8219 8219 8219 8219 8219 8219
110 France 161 161 161 161 161 172 172
111 France 14 14 14 14 14 14 14
112 France 780 780 780 780 780 855 855
113 France 159138 160053 160288 160946 162540 163754 165121
114 Gabon 9254 9254 9254 9283 9283 9310 9310
115 Gambia 3654 3656 3656 3656 3659 3659 3659
116 Georgia 171526 175842 180441 184668 188408 191968 194705
117 Germany 1095982 1107115 1123725 1147943 1171444 1197472 1220277
118 Ghana 52331 52331 52331 52675 52675 52777 52777
119 Greece 93764 93764 93764 93764 93764 93764 93764
120 Grenada 41 41 49 49 49 49 49
121 Guatemala 120257 120715 120994 121337 121936 122438 122965
122 Guinea 12859 12905 12955 13001 13001 13015 13039
123 Guinea-Bissau 2378 2378 2378 2378 2386 2386 2386
124 Guyana 5288 5305 5319 5369 5385 5448 5478
125 Haiti 8321 8336 8336 8404 8408 8413 8413
126 Holy See 15 15 15 15 15 15 15
127 Honduras 54002 54002 54267 54304 54446 54806 54806
128 Hungary 89814 93323 97443 102962 108676 114631 120529
129 Iceland 5449 5467 5478 5487 5500 5506 5506
130 India 9550712 9580402 9606111 9636487 9663382 9693173 9717834
131 Indonesia 531995 536260 541811 546884 552722 558703 563980
132 Iran 865474 875943 885054 894366 903998 914194 924685
133 Iraq 517091 519005 520969 522637 524344 525792 527341
134 Ireland 23364 23364 23364 23364 23364 23364 23364
135 Israel 344373 345590 348107 348874 351187 351876 354674
136 Italy 1226086 1249470 1261626 1281258 1301573 1322067 1344785
137 Jamaica 8668 8812 8966 9113 9266 9416 9579
138 Japan 160630 163152 165177 167357 169186 171959 174723
139 Jordan 236550 239126 243106 246168 249256 252158 254496
140 Kazakhstan 162074 162959 163834 164774 165950 167503 168805
141 Kenya 75274 75559 75735 76060 76222 76508 76720
142 Korea, South 34334 34722 35155 35928 36726 37425 38048
143 Kosovo 35792 36228 36570 36775 36775 37192 37192
144 Kuwait 143355 143641 143926 144142 144356 144594 144898
145 Kyrgyzstan 72051 72459 73005 73005 73300 73561 73870
146 Laos 36 36 36 37 37 37 37
147 Latvia 19072 20534 21051 21248 21816 22523 23402
148 Lebanon 106712 110535 112333 113948 115124 116143 117311
149 Lesotho 1445 1445 1445 1445 1445 1466 1466
150 Liberia 1406 1406 1406 1406 1406 1406 1406
151 Libya 63886 63886 64810 65532 66076 66756 67661
152 Liechtenstein 1424 1424 1424 1507 1542 1591 1591
153 Lithuania 46560 50587 50721 50863 54197 55926 60559
154 Luxembourg 35237 35237 35237 37106 37221 37574 37574
155 MS Zaandam 7 7 7 7 7 7 7
156 Madagascar 16992 16992 17147 17147 17147 17147 17147
157 Malawi 5662 5662 5663 5664 5668 5675 5676
158 Malaysia 75244 76242 77309 78393 79304 80014 81099
159 Maldives 12836 12878 12895 12929 12960 12983 13011
160 Mali 3771 3794 3839 3858 3884 3927 3968
161 Malta 9780 9881 9978 10115 10161 10293 10423
162 Marshall Islands 4 4 4 4 4 4 4
163 Mauritania 8426 8545 8909 8909 9005 9264 9490
164 Mauritius 489 489 489 489 496 496 496
165 Mexico 962397 971115 978002 987328 996302 1005248 1015256
166 Moldova 115612 117002 118635 120015 121402 122614 123924
167 Monaco 616 616 621 631 636 646 659
168 Mongolia 509 509 509 541 541 584 584
169 Montenegro 33491 33788 34082 34569 35149 35482 35809
170 Morocco 372725 375623 378154 380134 382925 385895 388728
171 Mozambique 15365 15451 15454 15733 15856 15856 16015
172 Namibia 15626 15849 15967 16041 16317 16892 17198
173 Nepal 241392 242567 243664 244743 245709 246661 247400
174 Netherlands 4928 4937 4957 4969 4997 5008 5031
175 Netherlands 166 172 172 172 172 174 174
176 Netherlands 2210 2249 2276 2284 2360 2385 2430
177 Netherlands 1157 1159 1184 1202 1214 1235 1238
178 Netherlands 0 0 0 0 0 0 0
179 New Zealand 2034 2036 2037 2037 2054 2054 2054
180 Nicaragua 4225 4225 4225 4225 4225 4225 4225
181 Niger 1377 1406 1418 1432 1508 1578 1579
182 Nigeria 67484 67784 68303 68493 68879 69274 69651
183 North Macedonia 52949 53345 54034 55155 56099 56743 57434
184 Norway 17998 17998 17998 17998 17998 17998 17998
185 Oman 119009 119009 119574 119745 119945 120178 120441
186 Pakistan 404501 407405 409085 410937 415352 417134 418958
187 Panama 170170 171745 173508 174951 176428 178140 180045
188 Papua New Guinea 601 601 601 601 601 601 661
189 Paraguay 70101 70943 71807 72721 73646 74573 75509
190 Peru 928219 930410 930410 932295 936182 936182 938341
191 Philippines 420666 421086 429134 429207 429419 429972 430490
192 Poland 915576 927723 938269 946017 954272 965178 975876
193 Portugal 290690 294814 297233 299603 304825 308446 312533
194 Qatar 139384 139521 139724 139927 140129 140264 140404
195 Romania 484948 493379 498777 501896 508979 516423 523829
196 Russia 2207398 2233060 2253826 2273510 2297289 2321362 2347700
197 Rwanda 6089 6089 6091 6100 6163 6163 6203
198 Saint Kitts and Nevis 24 24 24 25 25 25 26
199 Saint Lucia 253 253 258 261 263 264 267
200 Saint Vincent and the Grenadines 82 82 85 85 85 85 85
201 Samoa 2 2 2 2 2 2 2
202 San Marino 1733 1736 1736 1767 1825 1846 1863
203 Sao Tome and Principe 955 958 958 958 958 960 960
204 Saudi Arabia 351573 351722 351878 352089 352249 352418 352608
205 Senegal 16449 16493 16522 16562 16592 16657 16742
206 Serbia 0 0 0 0 0 0 0
207 Seychelles 184 184 184 184 184 184 184
208 Sierra Leone 1854 1854 1856 1856 1860 1866 1866
209 Singapore 58265 58274 58279 58287 58304 58322 58332
210 Slovakia 104560 106361 107828 109807 110565 112627 114267
211 Slovenia 80935 82541 83536 83977 87960 90100 91952
212 Solomon Islands 5 5 5 5 5 5 5
213 Somalia 3566 3566 3566 3566 3605 3605 3605
214 South Africa 783818 787782 793914 796346 808241 811372 822978
215 South Sudan 3090 3090 3090 3111 3111 3118 3118
216 Spain 150376 150376 150376 150376 150376 150376 150376
217 Sri Lanka 27061 27552 28267 28682 29300 29882 30568
218 Sudan 12873 13024 13171 13260 13524 13524 13524
219 Suriname 5249 5263 5291 5296 5323 5345 5388
220 Sweden 0 0 0 0 0 0 0
221 Switzerland 311500 311500 311500 311500 311500 311500 311500
222 Syria 4686 4737 4786 4835 4885 4927 4997
223 Taiwan* 619 625 627 627 632 635 635
224 Tajikistan 12333 12374 12413 12455 12496 12536 12578
225 Tanzania 183 183 183 183 183 183 183
226 Thailand 4024 4041 4053 4078 4078 4095 4130
227 Timor-Leste 30 35 31 31 31 31 31
228 Togo 2933 2974 3017 3054 3091 3131 3186
229 Trinidad and Tobago 6405 6426 6457 6471 6488 6495 6503
230 Tunisia 87884 87884 87884 87884 95763 97026 97776
231 Turkey 1753552 1779068 1800286 1834705 1866815 1901307 1935292
232 US 0 0 0 0 0 0 0
233 Uganda 10251 10360 10469 10549 10646 10731 10821
234 Ukraine 582457 596218 602993 608120 622519 638265 654592
235 United Arab Emirates 167306 168129 168995 169840 171451 172984 174479
236 United Kingdom 10 10 10 10 10 10 10
237 United Kingdom 261 267 276 276 291 321 338
238 United Kingdom 73 74 74 74 74 74 74
239 United Kingdom 282 282 282 288 288 290 290
240 United Kingdom 1470 1535 1535 1535 1535 1817 1898
241 United Kingdom 17 17 17 17 17 17 17
242 United Kingdom 1054 1058 1065 1069 1075 1075 1075
243 United Kingdom 344 344 345 346 346 346 346
244 United Kingdom 12 12 12 12 12 12 12
245 United Kingdom 741 755 759 759 761 761 761
246 United Kingdom 0 0 0 0 0 0 0
247 Uruguay 7699 8002 8327 8688 9127 9574 10040
248 Uzbekistan 72961 73099 73242 73339 73460 73589 73746
249 Vanuatu 1 1 1 1 1 1 1
250 Venezuela 103975 104208 104462 104799 104799 105249 105479
251 Vietnam 1266 1269 1269 1269 1281 1281 1281
252 West Bank and Gaza 94556 96461 97979 99547 101355 102942 105233
253 Yemen 1384 1384 1384 1384 1384 1384 1384
254 Zambia 17729 17756 17762 17818 17890 17969 18036
255 Zimbabwe 9894 9984 10024 10112 10159 10259 10314
In [5]:
deathdf=death_df[death_df.columns[1:2]]
deathdf=pd.concat([deathdf,death_df[death_df.columns[-7:]]],axis=1)
deathdf.head(313)
Out[5]:
Country/Region 12/18/20 12/19/20 12/20/20 12/21/20 12/22/20 12/23/20 12/24/20
0 Afghanistan 2030 2047 2067 2082 2096 2117 2126
1 Albania 1066 1074 1088 1098 1111 1117 1125
2 Algeria 2647 2659 2666 2675 2687 2696 2705
3 Andorra 80 80 81 81 82 82 83
4 Angola 384 386 387 390 393 393 393
5 Antigua and Barbuda 5 5 5 5 5 5 5
6 Argentina 41672 41763 41813 41997 42254 42314 42314
7 Armenia 2596 2616 2630 2656 2673 2691 2714
8 Australia 3 3 3 3 3 3 3
9 Australia 53 53 53 53 53 53 53
10 Australia 0 0 0 0 0 0 0
11 Australia 6 6 6 6 6 6 6
12 Australia 4 4 4 4 4 4 4
13 Australia 13 13 13 13 13 13 13
14 Australia 820 820 820 820 820 820 820
15 Australia 9 9 9 9 9 9 9
16 Austria 5127 5209 5351 5435 5540 5654 5745
17 Azerbaijan 2133 2175 2210 2253 2294 2340 2380
18 Bahamas 164 164 164 164 169 169 169
19 Bahrain 349 349 349 350 350 350 350
20 Bangladesh 7217 7242 7280 7312 7329 7359 7378
21 Barbados 7 7 7 7 7 7 7
22 Belarus 1308 1316 1324 1333 1341 1349 1358
23 Belgium 18455 18545 18626 18697 18821 18939 19038
24 Belize 213 213 213 224 226 226 228
25 Benin 44 44 44 44 44 44 44
26 Bhutan 0 0 0 0 0 0 0
27 Bolivia 9033 9035 9036 9043 9052 9065 9076
28 Bosnia and Herzegovina 3583 3625 3625 3706 3792 3838 3878
29 Botswana 38 38 38 38 38 38 40
30 Brazil 185650 186356 186764 187291 188259 189220 189982
31 Brunei 3 3 3 3 3 3 3
32 Bulgaria 6496 6551 6609 6765 6879 6978 7023
33 Burkina Faso 74 74 76 76 77 77 77
34 Burma 2398 2424 2443 2465 2484 2507 2532
35 Burundi 1 2 2 2 2 2 2
36 Cabo Verde 110 111 111 111 112 112 112
37 Cambodia 0 0 0 0 0 0 0
38 Cameroon 445 445 448 448 448 448 448
39 Canada 815 841 851 860 871 890 890
40 Canada 724 724 724 765 777 796 808
41 Canada 1 1 1 1 1 1 1
42 Canada 0 0 0 0 0 0 0
43 Canada 547 556 569 572 590 605 617
44 Canada 8 8 8 8 8 8 8
45 Canada 4 4 4 4 4 4 4
46 Canada 0 0 0 0 0 0 0
47 Canada 65 65 65 65 65 65 65
48 Canada 0 0 1 1 1 1 1
49 Canada 4112 4141 4167 4181 4207 4248 4303
50 Canada 0 0 0 0 0 0 0
51 Canada 7671 7715 7736 7766 7794 7867 7913
52 Canada 0 0 0 0 0 0 0
53 Canada 107 115 118 122 125 130 134
54 Canada 1 1 1 1 1 1 1
55 Central African Republic 63 63 63 63 63 63 63
56 Chad 102 102 102 102 102 102 102
57 Chile 16051 16101 16154 16197 16217 16228 16303
58 China 6 6 6 6 6 6 6
59 China 9 9 9 9 9 9 9
60 China 6 6 6 6 6 6 6
61 China 1 1 1 1 1 1 1
62 China 2 2 2 2 2 2 2
63 China 8 8 8 8 8 8 8
64 China 2 2 2 2 2 2 2
65 China 2 2 2 2 2 2 2
66 China 6 6 6 6 6 6 6
67 China 6 6 6 6 6 6 6
68 China 13 13 13 13 13 13 13
69 China 22 22 22 22 22 22 22
70 China 129 129 130 131 132 133 135
71 China 4512 4512 4512 4512 4512 4512 4512
72 China 4 4 4 4 4 4 4
73 China 1 1 1 1 1 1 1
74 China 0 0 0 0 0 0 0
75 China 1 1 1 1 1 1 1
76 China 2 2 2 2 2 2 2
77 China 2 2 2 2 2 2 2
78 China 0 0 0 0 0 0 0
79 China 0 0 0 0 0 0 0
80 China 0 0 0 0 0 0 0
81 China 3 3 3 3 3 3 3
82 China 7 7 7 7 7 7 7
83 China 7 7 7 7 7 7 7
84 China 0 0 0 0 0 0 0
85 China 3 3 3 3 3 3 3
86 China 3 3 3 3 3 3 3
87 China 0 0 0 0 0 0 0
88 China 3 3 3 3 3 3 3
89 China 2 2 2 2 2 2 2
90 China 1 1 1 1 1 1 1
91 Colombia 40019 40268 40475 40680 40931 41174 41454
92 Comoros 7 7 7 7 7 7 7
93 Congo (Brazzaville) 100 100 100 100 100 100 100
94 Congo (Kinshasa) 366 369 370 370 370 566 573
95 Costa Rica 1996 1996 1996 2037 2051 2065 2086
96 Cote d'Ivoire 133 133 133 133 133 133 133
97 Croatia 3023 3101 3177 3257 3328 3394 3464
98 Cuba 137 137 137 137 139 139 139
99 Cyprus 85 89 91 96 96 104 107
100 Czechia 10163 10271 10331 10411 10562 10664 10776
101 Denmark 0 0 0 0 0 0 0
102 Denmark 0 0 0 0 0 0 0
103 Denmark 1007 1019 1035 1053 1070 1096 1114
104 Diamond Princess 13 13 13 13 13 13 13
105 Djibouti 61 61 61 61 61 61 61
106 Dominica 0 0 0 0 0 0 0
107 Dominican Republic 2376 2382 2384 2385 2398 2401 2404
108 Ecuador 13942 13948 13948 13949 13949 13962 13977
109 Egypt 7041 7069 7098 7130 7167 7209 7260
110 El Salvador 1234 1242 1250 1257 1265 1274 1283
111 Equatorial Guinea 85 85 85 85 85 85 85
112 Eritrea 0 0 0 0 1 1 1
113 Estonia 168 170 174 181 187 192 195
114 Eswatini 136 137 140 141 142 153 154
115 Ethiopia 1843 1846 1853 1861 1864 1870 1882
116 Fiji 2 2 2 2 2 2 2
117 Finland 489 489 489 506 511 524 524
118 France 71 71 71 71 71 71 71
119 France 103 103 103 106 106 107 108
120 France 152 154 155 155 155 155 155
121 France 42 42 42 42 42 42 42
122 France 53 53 53 53 53 54 54
123 France 0 0 0 0 0 0 0
124 France 42 42 42 42 42 42 42
125 France 1 1 1 1 1 1 1
126 France 0 0 0 0 0 0 0
127 France 12 12 12 12 12 12 12
128 France 59869 60056 60186 60537 61339 61614 61904
129 Gabon 64 64 64 64 64 64 64
130 Gambia 123 123 123 123 123 123 123
131 Georgia 2002 2055 2094 2140 2182 2233 2276
132 Germany 25754 26171 26400 27110 28096 28909 29330
133 Ghana 331 331 331 333 333 333 333
134 Greece 4044 4102 4172 4257 4340 4402 4457
135 Grenada 0 0 0 0 0 0 0
136 Guatemala 4589 4624 4656 4688 4718 4739 4749
137 Guinea 80 80 80 80 80 80 80
138 Guinea-Bissau 44 44 44 44 45 45 45
139 Guyana 159 159 159 159 160 162 162
140 Haiti 234 234 234 234 234 234 234
141 Holy See 0 0 0 0 0 0 0
142 Honduras 3023 3023 3027 3034 3046 3054 3054
143 Hungary 7725 7914 8099 8282 8462 8616 8729
144 Iceland 28 28 28 28 28 28 28
145 India 145136 145477 145810 146111 146444 146756 147092
146 Indonesia 19514 19659 19880 20085 20257 20408 20589
147 Iran 53273 53448 53625 53816 54003 54156 54308
148 Iraq 12670 12680 12697 12710 12725 12737 12744
149 Ireland 2149 2154 2158 2158 2171 2184 2192
150 Israel 3057 3074 3099 3111 3136 3150 3171
151 Italy 67894 68447 68799 69214 69842 70395 70900
152 Jamaica 283 285 286 286 288 290 292
153 Japan 2709 2749 2784 2833 2877 2941 2967
154 Jordan 3518 3545 3568 3604 3627 3652 3681
155 Kazakhstan 2617 2621 2622 2626 2677 2677 2677
156 Kenya 1629 1633 1639 1644 1647 1648 1652
157 Korea, South 659 674 698 722 739 756 773
158 Kosovo 1240 1248 1256 1262 1262 1274 1274
159 Kuwait 916 918 921 922 923 924 926
160 Kyrgyzstan 1324 1328 1331 1331 1335 1337 1340
161 Laos 0 0 0 0 0 0 0
162 Latvia 409 427 439 443 459 479 486
163 Lebanon 1259 1270 1281 1294 1311 1333 1353
164 Lesotho 48 48 48 48 48 51 51
165 Liberia 83 83 83 83 83 83 83
166 Libya 1346 1346 1353 1369 1385 1393 1399
167 Liechtenstein 23 25 25 27 28 30 30
168 Lithuania 972 1005 1019 1039 1093 1143 1186
169 Luxembourg 434 434 434 450 453 458 458
170 MS Zaandam 2 2 2 2 2 2 2
171 Madagascar 259 259 260 260 260 260 260
172 Malawi 187 187 187 187 187 187 187
173 Malaysia 432 433 437 438 439 444 446
174 Maldives 48 48 48 48 48 48 48
175 Mali 215 220 222 225 225 229 235
176 Malta 183 187 190 194 196 201 203
177 Marshall Islands 0 0 0 0 0 0 0
178 Mauritania 264 273 281 286 290 297 301
179 Mauritius 10 10 10 10 10 10 10
180 Mexico 117249 117876 118202 118598 119495 120311 121172
181 Moldova 2700 2727 2752 2777 2803 2825 2848
182 Monaco 3 3 3 3 3 3 3
183 Mongolia 0 0 0 0 0 0 0
184 Montenegro 620 624 626 630 637 639 648
185 Morocco 6854 6909 6957 7000 7030 7086 7130
186 Mozambique 146 147 148 149 150 150 156
187 Namibia 169 171 177 180 181 183 187
188 Nepal 1765 1777 1788 1795 1798 1803 1808
189 Netherlands 47 47 47 47 47 47 47
190 Netherlands 3 3 3 3 3 3 3
191 Netherlands 11 11 11 11 11 12 12
192 Netherlands 26 26 26 26 26 26 26
193 Netherlands 10405 10459 10491 10519 10633 10737 10826
194 New Zealand 25 25 25 25 25 25 25
195 Nicaragua 163 163 163 163 163 164 164
196 Niger 85 86 87 87 89 89 90
197 Nigeria 1212 1218 1221 1227 1231 1236 1242
198 North Macedonia 2254 2274 2292 2314 2340 2354 2375
199 Norway 404 404 404 405 405 421 421
200 Oman 1483 1483 1488 1489 1490 1491 1491
201 Pakistan 9250 9330 9392 9474 9557 9668 9753
202 Panama 3504 3527 3566 3597 3632 3664 3715
203 Papua New Guinea 8 8 8 9 9 9 9
204 Paraguay 2050 2072 2088 2103 2120 2138 2154
205 Peru 36858 36858 37034 37103 37173 37218 37218
206 Philippines 8875 8911 8947 8957 9021 9048 9055
207 Poland 24771 25254 25397 25474 25783 26255 26752
208 Portugal 5977 6063 6134 6191 6254 6343 6413
209 Qatar 242 243 243 243 243 243 243
210 Romania 14157 14296 14394 14481 14636 14766 14912
211 Russia 49170 49744 50242 50723 51274 51810 52434
212 Rwanda 57 59 63 65 66 66 69
213 Saint Kitts and Nevis 0 0 0 0 0 0 0
214 Saint Lucia 5 5 5 5 5 5 5
215 Saint Vincent and the Grenadines 0 0 0 0 0 0 0
216 Samoa 0 0 0 0 0 0 0
217 San Marino 55 55 55 55 56 56 56
218 Sao Tome and Principe 17 17 17 17 17 17 17
219 Saudi Arabia 6101 6112 6122 6131 6139 6148 6159
220 Senegal 357 361 365 371 372 378 381
221 Serbia 2580 2632 2686 2733 2782 2833 2882
222 Seychelles 0 0 0 0 0 0 0
223 Sierra Leone 75 75 75 75 75 76 76
224 Singapore 29 29 29 29 29 29 29
225 Slovakia 1440 1510 1555 1618 1618 1686 1732
226 Slovenia 2274 2314 2353 2379 2418 2454 2479
227 Solomon Islands 0 0 0 0 0 0 0
228 Somalia 124 124 124 124 127 127 127
229 South Africa 24285 24539 24691 24907 25246 25657 25983
230 South Sudan 62 62 62 62 62 62 62
231 Spain 48926 48926 48926 49260 49520 49698 49824
232 Sri Lanka 165 171 176 181 183 184 185
233 Sudan 1408 1425 1434 1450 1468 1468 1468
234 Suriname 117 118 118 118 118 118 118
235 Sweden 7993 7993 7993 7993 8167 8279 8279
236 Switzerland 6561 6602 6622 6781 6924 7029 7098
237 Syria 591 601 610 621 630 641 652
238 Taiwan* 7 7 7 7 7 7 7
239 Tajikistan 89 89 89 89 89 89 89
240 Tanzania 21 21 21 21 21 21 21
241 Thailand 60 60 60 60 60 60 60
242 Timor-Leste 0 0 0 0 0 0 0
243 Togo 66 66 66 66 66 68 68
244 Trinidad and Tobago 123 123 123 125 125 125 125
245 Tunisia 4090 4126 4158 4199 4237 4275 4324
246 Turkey 17610 17851 18097 18351 18602 18861 19115
247 US 313610 316159 317668 319364 322765 326124 329023
248 Uganda 230 230 231 238 238 245 245
249 Ukraine 16848 17072 17201 17293 17535 17823 18057
250 United Arab Emirates 630 634 637 639 642 645 647
251 United Kingdom 0 0 0 0 0 0 0
252 United Kingdom 9 9 9 9 9 9 9
253 United Kingdom 1 1 1 1 1 1 1
254 United Kingdom 2 2 2 2 2 2 2
255 United Kingdom 49 52 52 52 52 56 57
256 United Kingdom 0 0 0 0 0 0 0
257 United Kingdom 6 6 6 6 6 6 6
258 United Kingdom 25 25 25 25 25 25 25
259 United Kingdom 1 1 1 1 1 1 1
260 United Kingdom 6 6 6 6 6 6 6
261 United Kingdom 66541 67075 67401 67616 68307 69051 69625
262 Uruguay 109 114 119 119 120 128 135
263 Uzbekistan 612 612 612 612 612 612 612
264 Vanuatu 0 0 0 0 0 0 0
265 Venezuela 979 984 988 993 997 1002 1006
266 Vietnam 35 35 35 35 35 35 35
267 West Bank and Gaza 1097 1117 1141 1169 1198 1226 1243
268 Yemen 606 606 606 606 606 606 606
269 Zambia 373 373 373 375 379 380 381
270 Zimbabwe 316 318 320 322 326 330 339
In [6]:
country_df.head(n=313)
Out[6]:
Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Incident_Rate People_Tested People_Hospitalized Mortality_Rate UID ISO3
0 Afghanistan 2020-12-25 08:22:41 33.939110 67.709953 50810.0 2139.0 40444.0 8227.0 130.521874 NaN NaN 4.209801 4 AFG
1 Albania 2020-12-25 08:22:41 41.153300 20.168300 54827.0 1125.0 30276.0 23426.0 1905.170616 NaN NaN 2.051909 8 ALB
2 Algeria 2020-12-25 08:22:41 28.033900 1.659600 97007.0 2705.0 64777.0 29525.0 221.219368 NaN NaN 2.788459 12 DZA
3 Andorra 2020-12-25 08:22:41 42.506300 1.521800 7699.0 83.0 7171.0 445.0 9964.408206 NaN NaN 1.078062 20 AND
4 Angola 2020-12-25 08:22:41 -11.202700 17.873900 17029.0 393.0 9729.0 6907.0 51.813002 NaN NaN 2.307828 24 AGO
5 Antigua and Barbuda 2020-12-25 08:22:41 17.060800 -61.796400 154.0 5.0 146.0 3.0 157.258394 NaN NaN 3.246753 28 ATG
6 Argentina 2020-12-25 08:22:41 -38.416100 -63.616700 1571680.0 42392.0 1384277.0 145011.0 3477.493041 NaN NaN 2.697241 32 ARG
7 Armenia 2020-12-25 08:22:41 40.069100 45.038200 156763.0 2733.0 137815.0 16215.0 5290.267323 NaN NaN 1.743396 51 ARM
8 Australia 2020-12-25 08:22:41 -25.000000 133.000000 28276.0 908.0 25726.0 1642.0 111.061796 NaN NaN 3.211204 36 AUS
9 Austria 2020-12-25 08:22:41 47.516200 14.550100 347204.0 5745.0 315952.0 25507.0 3855.080831 NaN NaN 1.654647 40 AUT
10 Azerbaijan 2020-12-25 08:22:41 40.143100 47.576900 210061.0 2380.0 155886.0 51795.0 2071.776057 NaN NaN 1.133004 31 AZE
11 Bahamas 2020-12-25 08:22:41 25.025885 -78.035889 7788.0 169.0 6166.0 1453.0 1980.429653 NaN NaN 2.170005 44 BHS
12 Bahrain 2020-12-25 08:22:41 26.027500 50.550000 91070.0 350.0 88963.0 1757.0 5352.075097 NaN NaN 0.384320 48 BHR
13 Bangladesh 2020-12-25 08:22:41 23.685000 90.356300 506102.0 7378.0 446690.0 52034.0 307.306999 NaN NaN 1.457809 50 BGD
14 Barbados 2020-12-25 08:22:41 13.193900 -59.543200 345.0 7.0 291.0 47.0 120.053868 NaN NaN 2.028986 52 BRB
15 Belarus 2020-12-25 08:22:41 53.709800 27.953400 181113.0 1358.0 159437.0 20318.0 1916.677399 NaN NaN 0.749808 112 BLR
16 Belgium 2020-12-25 08:22:41 50.833300 4.469936 634904.0 19038.0 NaN 615866.0 5478.214291 NaN NaN 2.998564 56 BEL
17 Belize 2020-12-25 08:22:41 17.189900 -88.497600 10490.0 228.0 9081.0 1181.0 2638.190639 NaN NaN 2.173499 84 BLZ
18 Benin 2020-12-25 08:22:41 9.307700 2.315800 3205.0 44.0 3061.0 100.0 26.436919 NaN NaN 1.372855 204 BEN
19 Bhutan 2020-12-25 08:22:41 27.514200 90.433600 541.0 0.0 442.0 99.0 70.112958 NaN NaN 0.000000 64 BTN
20 Bolivia 2020-12-25 08:22:41 -16.290200 -63.588700 153121.0 9076.0 129387.0 14658.0 1311.750361 NaN NaN 5.927339 68 BOL
21 Bosnia and Herzegovina 2020-12-25 08:22:41 43.915900 17.679100 108298.0 3878.0 73896.0 30524.0 3300.948088 NaN NaN 3.580860 70 BIH
22 Botswana 2020-12-25 08:22:41 -22.328500 24.684900 14025.0 40.0 11627.0 2358.0 596.396109 NaN NaN 0.285205 72 BWA
23 Brazil 2020-12-25 08:22:41 -14.235000 -51.925300 7423945.0 189982.0 6512717.0 721246.0 3492.644732 NaN NaN 2.559044 76 BRA
24 Brunei 2020-12-25 08:22:41 4.535300 114.727700 152.0 3.0 149.0 0.0 34.744207 NaN NaN 1.973684 96 BRN
25 Bulgaria 2020-12-25 08:22:41 42.733900 25.485800 196658.0 7023.0 107680.0 81955.0 2830.244753 NaN NaN 3.571174 100 BGR
26 Burkina Faso 2020-12-25 08:22:41 12.238300 -1.561600 5941.0 77.0 4129.0 1735.0 28.421380 NaN NaN 1.296078 854 BFA
27 Burma 2020-12-25 08:22:41 21.916200 95.956000 119788.0 2532.0 99927.0 17329.0 220.158893 NaN NaN 2.113734 104 MMR
28 Burundi 2020-12-25 08:22:41 -3.373100 29.918900 773.0 2.0 687.0 84.0 6.500835 NaN NaN 0.258732 108 BDI
29 Cabo Verde 2020-12-25 08:22:41 16.538800 -23.041800 11688.0 112.0 11366.0 210.0 2102.203645 NaN NaN 0.958248 132 CPV
30 Cambodia 2020-12-25 08:22:41 11.550000 104.916700 363.0 0.0 354.0 9.0 2.171186 NaN NaN 0.000000 116 KHM
31 Cameroon 2020-12-25 08:22:41 3.848000 11.502100 26277.0 448.0 24892.0 937.0 98.987172 NaN NaN 1.704913 120 CMR
32 Canada 2020-12-25 08:22:41 60.001000 -95.001000 538183.0 14745.0 448119.0 75319.0 1421.669581 NaN NaN 2.739774 124 CAN
33 Central African Republic 2020-12-25 08:22:41 6.611100 20.939400 4948.0 63.0 1924.0 2961.0 102.448070 NaN NaN 1.273242 140 CAF
34 Chad 2020-12-25 08:22:41 15.454200 18.732200 1958.0 102.0 1651.0 205.0 11.920229 NaN NaN 5.209397 148 TCD
35 Chile 2020-12-25 08:22:41 -35.675100 -71.543000 594152.0 16303.0 563457.0 14392.0 3108.105796 NaN NaN 2.743911 152 CHL
36 China 2020-12-25 08:22:41 30.592800 114.305500 95383.0 4769.0 89205.0 1409.0 6.790390 NaN NaN 4.999843 156 CHN
37 Colombia 2020-12-25 08:22:41 4.570900 -74.297300 1559766.0 41454.0 1417316.0 100996.0 3065.404076 NaN NaN 2.657706 170 COL
38 Comoros 2020-12-25 08:22:41 -11.645500 43.333300 715.0 7.0 626.0 82.0 82.222184 NaN NaN 0.979021 174 COM
39 Congo (Brazzaville) 2020-12-25 08:22:41 -0.228000 15.827700 6571.0 100.0 4988.0 1483.0 119.081016 NaN NaN 1.521838 178 COG
40 Congo (Kinshasa) 2020-12-25 08:22:41 -4.038300 21.758700 16282.0 573.0 13982.0 1727.0 18.179706 NaN NaN 3.519224 180 COD
41 Costa Rica 2020-12-25 08:22:41 9.748900 -83.753400 162990.0 2086.0 128842.0 32062.0 3199.575039 NaN NaN 1.279833 188 CRI
42 Cote d'Ivoire 2020-12-25 08:22:41 7.540000 -5.547100 22071.0 133.0 21629.0 309.0 83.671127 NaN NaN 0.602601 384 CIV
43 Croatia 2020-12-25 08:22:41 45.100000 15.200000 202319.0 3464.0 183532.0 15323.0 4928.277520 NaN NaN 1.712148 191 HRV
44 Cuba 2020-12-25 08:22:41 21.521757 -77.781167 10717.0 139.0 9378.0 1200.0 94.617845 NaN NaN 1.297005 192 CUB
45 Cyprus 2020-12-25 08:22:41 35.126400 33.429900 19316.0 107.0 2057.0 17152.0 1599.852902 NaN NaN 0.553945 196 CYP
46 Czechia 2020-12-25 08:22:41 49.817500 15.473000 664863.0 10859.0 557696.0 96308.0 6208.461271 NaN NaN 1.633269 203 CZE
47 Denmark 2020-12-25 08:22:41 56.263900 9.501800 146927.0 1114.0 102729.0 43084.0 2536.634161 NaN NaN 0.758200 208 DNK
48 Diamond Princess 2020-12-25 08:22:41 NaN NaN 712.0 13.0 699.0 0.0 NaN NaN NaN 1.825843 9999 NaN
49 Djibouti 2020-12-25 08:22:41 11.825100 42.590300 5800.0 61.0 5690.0 49.0 587.043346 NaN NaN 1.051724 262 DJI
50 Dominica 2020-12-25 08:22:41 15.415000 -61.371000 88.0 0.0 83.0 5.0 122.237502 NaN NaN 0.000000 212 DMA
51 Dominican Republic 2020-12-25 08:22:41 18.735700 -70.162700 163654.0 2404.0 126732.0 34518.0 1508.623233 NaN NaN 1.468953 214 DOM
52 Ecuador 2020-12-25 08:22:41 -1.831200 -78.183400 208010.0 13977.0 181618.0 12415.0 1178.990493 NaN NaN 6.719388 218 ECU
53 Egypt 2020-12-25 08:22:41 26.820553 30.802498 128993.0 7260.0 108474.0 13259.0 126.050474 NaN NaN 5.628212 818 EGY
54 El Salvador 2020-12-25 08:22:41 13.794200 -88.896500 44619.0 1289.0 39989.0 3341.0 687.906526 NaN NaN 2.888904 222 SLV
55 Equatorial Guinea 2020-12-25 08:22:41 1.650800 10.267900 5236.0 85.0 5078.0 73.0 373.204275 NaN NaN 1.623377 226 GNQ
56 Eritrea 2020-12-25 08:22:41 15.179400 39.782300 951.0 1.0 600.0 350.0 26.815722 NaN NaN 0.105152 232 ERI
57 Estonia 2020-12-25 08:22:41 58.595300 25.013600 24009.0 195.0 15393.0 8421.0 1809.897787 NaN NaN 0.812195 233 EST
58 Eswatini 2020-12-25 08:22:41 -26.522500 31.465900 8032.0 154.0 6952.0 926.0 692.315914 NaN NaN 1.917331 748 SWZ
59 Ethiopia 2020-12-25 08:22:41 9.145000 40.489700 121399.0 1882.0 106845.0 12672.0 105.597787 NaN NaN 1.550260 231 ETH
60 Fiji 2020-12-25 08:22:41 -17.713400 178.065000 46.0 2.0 44.0 0.0 5.131386 NaN NaN 4.347826 242 FJI
61 Finland 2020-12-25 08:22:41 61.924100 25.748200 34447.0 524.0 26000.0 7923.0 621.706429 NaN NaN 1.521177 246 FIN
62 France 2020-12-25 08:22:41 46.227600 2.213700 2584333.0 62389.0 194559.0 2327385.0 3959.236941 NaN NaN 2.414124 250 FRA
63 Gabon 2020-12-25 08:22:41 -0.803700 11.609400 9469.0 64.0 9310.0 95.0 425.433836 NaN NaN 0.675890 266 GAB
64 Gambia 2020-12-25 08:22:41 13.443200 -15.310100 3791.0 123.0 3659.0 9.0 156.869139 NaN NaN 3.244527 270 GMB
65 Georgia 2020-12-25 08:22:41 42.315400 43.356900 218724.0 2313.0 196220.0 20191.0 5482.938202 NaN NaN 1.057497 268 GEO
66 Germany 2020-12-25 08:22:41 51.165691 10.451526 1630596.0 29333.0 1220277.0 380986.0 1946.191481 NaN NaN 1.798913 276 DEU
67 Ghana 2020-12-25 08:22:41 7.946500 -1.023200 54043.0 333.0 52777.0 933.0 173.923006 NaN NaN 0.616176 288 GHA
68 Greece 2020-12-25 08:22:41 39.074200 21.824300 134235.0 4457.0 93764.0 36014.0 1287.866054 NaN NaN 3.320296 300 GRC
69 Grenada 2020-12-25 08:22:41 12.116500 -61.679000 105.0 0.0 49.0 56.0 93.317573 NaN NaN 0.000000 308 GRD
70 Guatemala 2020-12-25 08:22:41 15.783500 -90.230800 134894.0 4749.0 122965.0 7180.0 752.942957 NaN NaN 3.520542 320 GTM
71 Guinea 2020-12-25 08:22:41 9.945600 -9.696600 13630.0 80.0 13039.0 511.0 103.786004 NaN NaN 0.586941 324 GIN
72 Guinea-Bissau 2020-12-25 08:22:41 11.803700 -15.180400 2447.0 45.0 2386.0 16.0 124.339557 NaN NaN 1.838987 624 GNB
73 Guyana 2020-12-25 08:22:41 4.860416 -58.930180 6266.0 162.0 5478.0 626.0 796.634455 NaN NaN 2.585381 328 GUY
74 Haiti 2020-12-25 08:22:41 18.971200 -72.285200 9805.0 234.0 8413.0 1158.0 85.989666 NaN NaN 2.386537 332 HTI
75 Holy See 2020-12-25 08:22:41 41.902900 12.453400 27.0 0.0 15.0 12.0 3337.453646 NaN NaN 0.000000 336 VAT
76 Honduras 2020-12-25 08:22:41 15.200000 -86.241900 118036.0 3054.0 54806.0 60176.0 1191.728133 NaN NaN 2.587346 340 HND
77 Hungary 2020-12-25 08:22:41 47.162500 19.503300 311554.0 8729.0 120529.0 182296.0 3225.079837 NaN NaN 2.801761 348 HUN
78 Iceland 2020-12-25 08:22:41 64.963100 -19.020800 5683.0 28.0 5506.0 149.0 1665.347985 NaN NaN 0.492698 352 ISL
79 India 2020-12-25 08:22:41 20.593684 78.962880 10146845.0 147092.0 9717834.0 281919.0 735.276287 NaN NaN 1.449633 356 IND
80 Indonesia 2020-12-25 08:22:41 -0.789300 113.921300 692838.0 20589.0 563980.0 108269.0 253.300975 NaN NaN 2.971690 360 IDN
81 Iran 2020-12-25 08:22:41 32.427908 53.688046 1183182.0 54308.0 924685.0 204189.0 1408.668177 NaN NaN 4.589995 364 IRN
82 Iraq 2020-12-25 08:22:41 33.223191 43.679291 588803.0 12744.0 527341.0 48718.0 1463.864643 NaN NaN 2.164391 368 IRQ
83 Ireland 2020-12-25 08:22:41 53.142400 -7.692100 83073.0 2192.0 23364.0 57517.0 1682.390281 NaN NaN 2.638643 372 IRL
84 Israel 2020-12-25 08:22:41 31.046051 34.851612 393036.0 3171.0 356058.0 33807.0 4540.860011 NaN NaN 0.806796 376 ISR
85 Italy 2020-12-25 08:22:41 41.871900 12.567400 2009317.0 70900.0 1344785.0 593632.0 3323.281923 NaN NaN 3.528562 380 ITA
86 Jamaica 2020-12-25 08:22:41 18.109600 -77.297500 12519.0 292.0 9579.0 2648.0 422.773365 NaN NaN 2.332455 388 JAM
87 Japan 2020-12-25 08:22:41 36.204824 138.252924 212503.0 2974.0 174723.0 34806.0 168.017830 NaN NaN 1.399510 392 JPN
88 Jordan 2020-12-25 08:22:41 31.240000 36.510000 283690.0 3681.0 254496.0 25513.0 2780.418577 NaN NaN 1.297543 400 JOR
89 Kazakhstan 2020-12-25 08:22:41 48.019600 66.923700 195303.0 2682.0 168961.0 23660.0 1040.134460 NaN NaN 1.373251 398 KAZ
90 Kenya 2020-12-25 08:22:41 -0.023600 37.906200 95431.0 1652.0 76720.0 17059.0 177.475717 NaN NaN 1.731094 404 KEN
91 Korea, South 2020-12-25 08:22:41 35.907757 127.766922 54770.0 773.0 38048.0 15949.0 106.828307 NaN NaN 1.411357 410 KOR
92 Kosovo 2020-12-25 08:22:41 42.602636 20.902977 49440.0 1274.0 37192.0 10974.0 2730.939490 NaN NaN 2.576861 383 XKS
93 Kuwait 2020-12-25 08:22:41 29.311660 47.481766 149017.0 926.0 144898.0 3193.0 3489.399407 NaN NaN 0.621406 414 KWT
94 Kyrgyzstan 2020-12-25 08:22:41 41.204380 74.766098 80025.0 1340.0 74177.0 4508.0 1226.588860 NaN NaN 1.674477 417 KGZ
95 Laos 2020-12-25 08:22:41 19.856270 102.495496 41.0 0.0 37.0 4.0 0.563531 NaN NaN 0.000000 418 LAO
96 Latvia 2020-12-25 08:22:41 56.879600 24.603200 34754.0 486.0 23402.0 10866.0 1842.538604 NaN NaN 1.398400 428 LVA
97 Lebanon 2020-12-25 08:22:41 33.854700 35.862300 165933.0 1353.0 117311.0 47269.0 2431.095305 NaN NaN 0.815389 422 LBN
98 Lesotho 2020-12-25 08:22:41 -29.610000 28.233600 2725.0 51.0 1466.0 1208.0 127.202589 NaN NaN 1.871560 426 LSO
99 Liberia 2020-12-25 08:22:41 6.428055 -9.429499 1779.0 83.0 1406.0 290.0 35.174251 NaN NaN 4.665542 430 LBR
100 Libya 2020-12-25 08:22:41 26.335100 17.228331 97192.0 1399.0 67661.0 28132.0 1414.465733 NaN NaN 1.439419 434 LBY
101 Liechtenstein 2020-12-25 08:22:41 47.140000 9.550000 1920.0 30.0 1591.0 299.0 5034.480950 NaN NaN 1.562500 438 LIE
102 Lithuania 2020-12-25 08:22:41 55.169400 23.881300 126581.0 1205.0 60946.0 64430.0 4649.796807 NaN NaN 0.951960 440 LTU
103 Luxembourg 2020-12-25 08:22:41 49.815300 6.129600 45209.0 458.0 37574.0 7177.0 7222.161872 NaN NaN 1.013073 442 LUX
104 MS Zaandam 2020-12-25 08:22:41 NaN NaN 9.0 2.0 7.0 0.0 NaN NaN NaN 22.222222 8888 NaN
105 Madagascar 2020-12-25 08:22:41 -18.766947 46.869107 17633.0 260.0 17147.0 226.0 63.677686 NaN NaN 1.474508 450 MDG
106 Malawi 2020-12-25 08:22:41 -13.254300 34.301500 6277.0 187.0 5676.0 414.0 32.812414 NaN NaN 2.979130 454 MWI
107 Malaysia 2020-12-25 08:22:41 4.210484 101.975766 100318.0 446.0 81099.0 18773.0 309.948731 NaN NaN 0.444586 458 MYS
108 Maldives 2020-12-25 08:22:41 3.202800 73.220700 13558.0 48.0 13011.0 499.0 2508.223228 NaN NaN 0.354035 462 MDV
109 Mali 2020-12-25 08:22:41 17.570692 -3.996166 6441.0 235.0 3968.0 2238.0 31.806097 NaN NaN 3.648502 466 MLI
110 Malta 2020-12-25 08:22:41 35.937500 14.375400 12062.0 203.0 10423.0 1436.0 2731.808515 NaN NaN 1.682971 470 MLT
111 Marshall Islands 2020-12-25 08:22:41 7.131500 171.184500 4.0 0.0 4.0 0.0 6.847791 NaN NaN 0.000000 584 MHL
112 Mauritania 2020-12-25 08:22:41 21.007900 -10.940800 13118.0 301.0 9490.0 3327.0 282.128156 NaN NaN 2.294557 478 MRT
113 Mauritius 2020-12-25 08:22:41 -20.348404 57.552152 527.0 10.0 496.0 21.0 41.438408 NaN NaN 1.897533 480 MUS
114 Mexico 2020-12-25 08:22:41 23.634500 -102.552800 1362564.0 121172.0 1015256.0 226136.0 1066.233372 NaN NaN 8.892940 484 MEX
115 Moldova 2020-12-25 08:22:41 47.411600 28.369900 139435.0 2848.0 123924.0 12663.0 3456.526498 NaN NaN 2.042529 498 MDA
116 Monaco 2020-12-25 08:22:41 43.733300 7.416700 783.0 3.0 659.0 121.0 1995.209459 NaN NaN 0.383142 492 MCO
117 Mongolia 2020-12-25 08:22:41 46.862500 103.846700 1075.0 0.0 584.0 491.0 32.791466 NaN NaN 0.000000 496 MNG
118 Montenegro 2020-12-25 08:22:41 42.708678 19.374390 45423.0 648.0 35809.0 8966.0 7232.247772 NaN NaN 1.426590 499 MNE
119 Morocco 2020-12-25 08:22:41 31.791700 -7.092600 425864.0 7130.0 388728.0 30006.0 1153.772858 NaN NaN 1.674243 504 MAR
120 Mozambique 2020-12-25 08:22:41 -18.665695 35.529562 18031.0 156.0 16015.0 1860.0 57.689167 NaN NaN 0.865177 508 MOZ
121 Namibia 2020-12-25 08:22:41 -22.957600 18.490400 20579.0 187.0 17198.0 3194.0 809.904774 NaN NaN 0.908693 516 NAM
122 Nepal 2020-12-25 08:22:41 28.166700 84.250000 256592.0 1808.0 247400.0 7384.0 880.645539 NaN NaN 0.704621 524 NPL
123 Netherlands 2020-12-25 08:22:41 52.316700 5.550000 743493.0 10914.0 8873.0 723706.0 4339.063383 NaN NaN 1.467936 528 NLD
124 New Zealand 2020-12-25 08:22:41 -40.900600 174.886000 2128.0 25.0 2054.0 49.0 44.128934 NaN NaN 1.174812 554 NZL
125 Nicaragua 2020-12-25 08:22:41 12.865416 -85.207229 5991.0 164.0 4225.0 1602.0 90.436277 NaN NaN 2.737439 558 NIC
126 Niger 2020-12-25 08:22:41 17.607789 8.081666 2933.0 90.0 1579.0 1264.0 12.116512 NaN NaN 3.068531 562 NER
127 Nigeria 2020-12-25 08:22:41 9.082000 8.675300 81963.0 1242.0 69651.0 11070.0 39.760922 NaN NaN 1.515318 566 NGA
128 North Macedonia 2020-12-25 08:22:41 41.608600 21.745300 80407.0 2375.0 57434.0 20598.0 3859.449548 NaN NaN 2.953723 807 MKD
129 Norway 2020-12-25 08:22:41 60.472000 8.468900 45931.0 421.0 17998.0 27512.0 847.241278 NaN NaN 0.916592 578 NOR
130 Oman 2020-12-25 08:22:41 21.512583 55.923255 128290.0 1491.0 120441.0 6358.0 2512.228240 NaN NaN 1.162211 512 OMN
131 Pakistan 2020-12-25 08:22:41 30.375300 69.345100 467222.0 9753.0 418958.0 38511.0 211.515718 NaN NaN 2.087445 586 PAK
132 Panama 2020-12-25 08:22:41 8.538000 -80.782100 223674.0 3715.0 180045.0 39914.0 5183.917189 NaN NaN 1.660899 591 PAN
133 Papua New Guinea 2020-12-25 08:22:41 -6.314993 143.955550 780.0 9.0 661.0 110.0 8.717980 NaN NaN 1.153846 598 PNG
134 Paraguay 2020-12-25 08:22:41 -23.442500 -58.443800 103329.0 2154.0 75509.0 25666.0 1448.700531 NaN NaN 2.084604 600 PRY
135 Peru 2020-12-25 08:22:41 -9.190000 -75.015200 1000153.0 37218.0 938341.0 24594.0 3033.354578 NaN NaN 3.721231 604 PER
136 Philippines 2020-12-25 08:22:41 12.879721 121.774017 465724.0 9055.0 430490.0 26179.0 425.004005 NaN NaN 1.944285 608 PHL
137 Poland 2020-12-25 08:22:41 51.919400 19.145100 1239998.0 26752.0 975876.0 237370.0 3276.378423 NaN NaN 2.157423 616 POL
138 Portugal 2020-12-25 08:22:41 39.399900 -8.224500 387636.0 6413.0 312533.0 68690.0 3801.580255 NaN NaN 1.654387 620 PRT
139 Qatar 2020-12-25 08:22:41 25.354800 51.183900 142605.0 243.0 140404.0 1958.0 4949.740720 NaN NaN 0.170401 634 QAT
140 Romania 2020-12-25 08:22:41 45.943200 24.966800 608561.0 14912.0 523829.0 69820.0 3163.380079 NaN NaN 2.450371 642 ROU
141 Russia 2020-12-25 08:22:41 61.524000 105.318800 2934695.0 52434.0 2347700.0 534561.0 2010.967800 NaN NaN 1.786693 643 RUS
142 Rwanda 2020-12-25 08:22:41 -1.940300 29.873900 7670.0 69.0 6203.0 1398.0 59.217698 NaN NaN 0.899609 646 RWA
143 Saint Kitts and Nevis 2020-12-25 08:22:41 17.357822 -62.782998 30.0 0.0 26.0 4.0 56.399459 NaN NaN 0.000000 659 KNA
144 Saint Lucia 2020-12-25 08:22:41 13.909400 -60.978900 305.0 5.0 267.0 33.0 166.095769 NaN NaN 1.639344 662 LCA
145 Saint Vincent and the Grenadines 2020-12-25 08:22:41 12.984300 -61.287200 108.0 0.0 85.0 23.0 97.343777 NaN NaN 0.000000 670 VCT
146 Samoa 2020-12-25 08:22:41 -13.759000 -172.104600 2.0 0.0 2.0 0.0 1.019732 NaN NaN 0.000000 882 WSM
147 San Marino 2020-12-25 08:22:41 43.942400 12.457800 2231.0 56.0 1863.0 312.0 6573.752136 NaN NaN 2.510085 674 SMR
148 Sao Tome and Principe 2020-12-25 08:22:41 0.186400 6.613100 1012.0 17.0 960.0 35.0 461.760988 NaN NaN 1.679842 678 STP
149 Saudi Arabia 2020-12-25 08:22:41 23.885942 45.079162 361725.0 6159.0 352608.0 2958.0 1039.025627 NaN NaN 1.702675 682 SAU
150 Senegal 2020-12-25 08:22:41 14.497400 -14.452400 18200.0 381.0 16742.0 1077.0 108.696107 NaN NaN 2.093407 686 SEN
151 Serbia 2020-12-25 08:22:41 44.016500 21.005900 316344.0 2882.0 NaN 313462.0 3620.586057 NaN NaN 0.911034 688 SRB
152 Seychelles 2020-12-25 08:22:41 -4.679600 55.492000 205.0 0.0 184.0 21.0 208.460443 NaN NaN 0.000000 690 SYC
153 Sierra Leone 2020-12-25 08:22:41 8.460555 -11.779889 2531.0 76.0 1866.0 589.0 31.728780 NaN NaN 3.002766 694 SLE
154 Singapore 2020-12-25 08:22:41 1.283300 103.833300 58509.0 29.0 58332.0 148.0 1000.095208 NaN NaN 0.049565 702 SGP
155 Slovakia 2020-12-25 08:22:41 48.669000 19.699000 161562.0 1732.0 114267.0 45563.0 2959.204475 NaN NaN 1.072034 703 SVK
156 Slovenia 2020-12-25 08:22:41 46.151200 14.995500 112021.0 2479.0 91952.0 17590.0 5388.391732 NaN NaN 2.212978 705 SVN
157 Solomon Islands 2020-12-25 08:22:41 -9.645700 160.156200 17.0 0.0 5.0 12.0 2.603935 NaN NaN 0.000000 90 SLB
158 Somalia 2020-12-25 08:22:41 5.152149 46.199616 4690.0 127.0 3605.0 958.0 29.509440 NaN NaN 2.707889 706 SOM
159 South Africa 2020-12-25 08:22:41 -30.559500 22.937500 968563.0 25983.0 822978.0 119602.0 1633.087832 NaN NaN 2.682634 710 ZAF
160 South Sudan 2020-12-25 08:22:41 6.877000 31.307000 3455.0 62.0 3118.0 275.0 30.865496 NaN NaN 1.794501 728 SSD
161 Spain 2020-12-25 08:22:41 40.463667 -3.749220 1854951.0 49824.0 150376.0 1654751.0 3967.403720 NaN NaN 2.686001 724 ESP
162 Sri Lanka 2020-12-25 08:22:41 7.873054 80.771797 39231.0 185.0 30568.0 8478.0 183.208994 NaN NaN 0.471566 144 LKA
163 Sudan 2020-12-25 08:22:41 12.862800 30.217600 23316.0 1468.0 13524.0 8324.0 53.173064 NaN NaN 6.296106 729 SDN
164 Suriname 2020-12-25 08:22:41 3.919300 -56.027800 5810.0 118.0 5388.0 304.0 990.396056 NaN NaN 2.030981 740 SUR
165 Sweden 2020-12-25 08:22:41 60.128200 18.643500 396048.0 8279.0 NaN 387769.0 3921.550766 NaN NaN 2.090403 752 SWE
166 Switzerland 2020-12-25 08:22:41 46.818200 8.227500 428197.0 7098.0 311500.0 109599.0 4947.612939 NaN NaN 1.657648 756 CHE
167 Syria 2020-12-25 08:22:41 34.802075 38.996815 10701.0 652.0 4997.0 5052.0 61.146276 NaN NaN 6.092889 760 SYR
168 Taiwan* 2020-12-25 08:22:41 23.700000 121.000000 776.0 7.0 635.0 134.0 3.258208 NaN NaN 0.902062 158 TWN
169 Tajikistan 2020-12-25 08:22:41 38.861000 71.276100 13106.0 89.0 12578.0 439.0 137.413419 NaN NaN 0.679078 762 TJK
170 Tanzania 2020-12-25 08:22:41 -6.369028 34.888822 509.0 21.0 183.0 305.0 0.852108 NaN NaN 4.125737 834 TZA
171 Thailand 2020-12-25 08:22:41 15.870032 100.992541 5910.0 60.0 4130.0 1720.0 8.467051 NaN NaN 1.015228 764 THA
172 Timor-Leste 2020-12-25 08:22:41 -8.874217 125.727539 41.0 0.0 31.0 10.0 3.109731 NaN NaN 0.000000 626 TLS
173 Togo 2020-12-25 08:22:41 8.619500 0.824800 3520.0 68.0 3186.0 266.0 42.518563 NaN NaN 1.931818 768 TGO
174 Trinidad and Tobago 2020-12-25 08:22:41 10.691800 -61.222500 7089.0 125.0 6503.0 461.0 506.541307 NaN NaN 1.763295 780 TTO
175 Tunisia 2020-12-25 08:22:41 33.886917 9.537499 126752.0 4324.0 97776.0 24652.0 1072.477340 NaN NaN 3.411386 788 TUN
176 Turkey 2020-12-25 08:22:41 38.963700 35.243300 2100712.0 19115.0 1935292.0 146305.0 2490.793501 NaN NaN 0.909930 792 TUR
177 US 2020-12-25 08:22:41 40.000000 -100.000000 18654396.0 329097.0 NaN 18325168.0 5662.004570 NaN NaN 1.764179 840 USA
178 Uganda 2020-12-25 08:22:41 1.373333 32.290275 32914.0 245.0 10821.0 21848.0 71.957325 NaN NaN 0.744364 800 UGA
179 Ukraine 2020-12-25 08:22:41 48.379400 31.165600 1041160.0 18243.0 669929.0 352988.0 2380.678048 NaN NaN 1.752180 804 UKR
180 United Arab Emirates 2020-12-25 08:22:41 23.424076 53.847818 198435.0 647.0 174479.0 23309.0 2006.339481 NaN NaN 0.326051 784 ARE
181 United Kingdom 2020-12-25 08:22:41 55.000000 -3.000000 2195144.0 69732.0 4821.0 2120591.0 3233.573742 NaN NaN 3.176648 826 GBR
182 Uruguay 2020-12-25 08:22:41 -32.522800 -55.765800 15457.0 135.0 10040.0 5282.0 444.968761 NaN NaN 0.873391 858 URY
183 Uzbekistan 2020-12-25 08:22:41 41.377491 64.585262 76568.0 612.0 73911.0 2045.0 228.771534 NaN NaN 0.799290 860 UZB
184 Vanuatu 2020-12-25 08:22:41 -15.376700 166.959200 1.0 0.0 1.0 0.0 0.341670 NaN NaN 0.000000 548 VUT
185 Venezuela 2020-12-25 08:22:41 6.423800 -66.589700 111245.0 1006.0 105479.0 4760.0 391.212628 NaN NaN 0.904310 862 VEN
186 Vietnam 2020-12-25 08:22:41 14.058324 108.277199 1432.0 35.0 1281.0 116.0 1.471154 NaN NaN 2.444134 704 VNM
187 West Bank and Gaza 2020-12-25 08:22:41 31.952200 35.233200 129080.0 1243.0 105233.0 22604.0 2530.277868 NaN NaN 0.962969 275 PSE
188 Yemen 2020-12-25 08:22:41 15.552727 48.516388 2092.0 606.0 1384.0 102.0 7.014022 NaN NaN 28.967495 887 YEM
189 Zambia 2020-12-25 08:22:41 -13.133897 27.849332 19234.0 381.0 18036.0 817.0 104.623836 NaN NaN 1.980867 894 ZMB
190 Zimbabwe 2020-12-25 08:22:41 -19.015438 29.154857 12786.0 339.0 10314.0 2133.0 86.026124 NaN NaN 2.651337 716 ZWE
In [7]:
# data cleaning

# renaming the df column names to lowercase
country_df.columns = map(str.lower, country_df.columns)
confirmed_df.columns = map(str.lower, confirmed_df.columns)
death_df.columns = map(str.lower, death_df.columns)
recovered_df.columns = map(str.lower, recovered_df.columns)

# changing province/state to state and country/region to country
confirmed_df = confirmed_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
recovered_df = confirmed_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
death_df = death_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
country_df = country_df.rename(columns={'country_region': 'country'})
# country_df.head()
In [8]:
# total number of confirmed, death and recovered cases
confirmed_total = int(country_df['confirmed'].sum())
deaths_total = int(country_df['deaths'].sum())
recovered_total = int(country_df['recovered'].sum())
active_total = int(country_df['active'].sum())
In [9]:
# displaying the total stats

display(HTML("<div style = 'background-color: #FFFFFF; padding: 30px '>" +
             "<span style='color: #1F487E; font-size:30px;'> Confirmed: "  + str(confirmed_total) +"</span>" +
             "<span style='color: #FF5964; font-size:30px;margin-left:20px;'> Deaths: " + str(deaths_total) + "</span>"+
             "<span style='color: #1F487E; font-size:30px; margin-left:20px;'> Recovered: " + str(recovered_total) + "</span>"+
             "</div>")
       )
Confirmed: 79406417 Deaths: 1742801 Recovered: 44737410
In [10]:
# sorting the values by confirmed descednding order
# country_df.sort_values('confirmed', ascending= False).head(10).style.background_gradient(cmap='copper')
fig = go.FigureWidget( layout=go.Layout() )
def highlight_col(x):
    r = 'background-color: #1D3461'
    y = 'background-color: #FF5964'
    g = 'background-color: #1F487E'
    df1 = pd.DataFrame('', index=x.index, columns=x.columns)
    df1.iloc[:, 4] = y
    df1.iloc[:, 5] = r
    df1.iloc[:, 6] = g
    
    return df1

def show_latest_cases(n):
    n = int(n)
    return country_df.sort_values('confirmed', ascending= False).head(n).style.apply(highlight_col, axis=None)

interact(show_latest_cases, n='10')

ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none' # uncomment this, run cell again - then the graph/figure disappears
widgets.VBox([fig], layout=ipywLayout)
country last_update lat long_ confirmed deaths recovered active incident_rate people_tested people_hospitalized mortality_rate uid iso3
177 US 2020-12-25 08:22:41 40.000000 -100.000000 18654396.000000 329097.000000 nan 18325168.000000 5662.004570 nan nan 1.764179 840 USA
79 India 2020-12-25 08:22:41 20.593684 78.962880 10146845.000000 147092.000000 9717834.000000 281919.000000 735.276287 nan nan 1.449633 356 IND
23 Brazil 2020-12-25 08:22:41 -14.235000 -51.925300 7423945.000000 189982.000000 6512717.000000 721246.000000 3492.644732 nan nan 2.559044 76 BRA
141 Russia 2020-12-25 08:22:41 61.524000 105.318800 2934695.000000 52434.000000 2347700.000000 534561.000000 2010.967800 nan nan 1.786693 643 RUS
62 France 2020-12-25 08:22:41 46.227600 2.213700 2584333.000000 62389.000000 194559.000000 2327385.000000 3959.236941 nan nan 2.414124 250 FRA
181 United Kingdom 2020-12-25 08:22:41 55.000000 -3.000000 2195144.000000 69732.000000 4821.000000 2120591.000000 3233.573742 nan nan 3.176648 826 GBR
176 Turkey 2020-12-25 08:22:41 38.963700 35.243300 2100712.000000 19115.000000 1935292.000000 146305.000000 2490.793501 nan nan 0.909930 792 TUR
85 Italy 2020-12-25 08:22:41 41.871900 12.567400 2009317.000000 70900.000000 1344785.000000 593632.000000 3323.281923 nan nan 3.528562 380 ITA
161 Spain 2020-12-25 08:22:41 40.463667 -3.749220 1854951.000000 49824.000000 150376.000000 1654751.000000 3967.403720 nan nan 2.686001 724 ESP
66 Germany 2020-12-25 08:22:41 51.165691 10.451526 1630596.000000 29333.000000 1220277.000000 380986.000000 1946.191481 nan nan 1.798913 276 DEU
In [11]:
sorted_country_df = country_df.sort_values('confirmed', ascending= False)

Slide to check for the worst hit countries

In [12]:
# # plotting the 20 worst hit countries

def bubble_chart(n):
    fig = px.scatter(sorted_country_df.head(n), x="country", y="confirmed", size="confirmed", color="country",
               hover_name="country", size_max=60)
    fig.update_layout(
    title=str(n) +" Worst hit countries",
    xaxis_title="Countries",
    yaxis_title="Confirmed Cases",
    width = 700
    )
    fig.show();

interact(bubble_chart, n=10)

ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none'
widgets.VBox([fig], layout=ipywLayout)
In [13]:
def plot_cases_of_a_country(country):
    labels = ['confirmed', 'deaths']
    colors = ['blue', 'red']
    mode_size = [6, 8]
    line_size = [4, 5]
    
    df_list = [confirmed_df, death_df]
    
    fig = go.Figure();
    
    for i, df in enumerate(df_list):
        if country == 'World' or country == 'world':
            x_data = np.array(list(df.iloc[:, 20:].columns))
            y_data = np.sum(np.asarray(df.iloc[:,4:]),axis = 0)
            
        else:    
            x_data = np.array(list(df.iloc[:, 20:].columns))
            y_data = np.sum(np.asarray(df[df['country'] == country].iloc[:,20:]),axis = 0)
            
        fig.add_trace(go.Scatter(x=x_data, y=y_data, mode='lines+markers',
        name=labels[i],
        line=dict(color=colors[i], width=line_size[i]),
        connectgaps=True,
        text = "Total " + str(labels[i]) +": "+ str(y_data[-1])
        ));
    
    fig.update_layout(
        title="COVID 19 cases of " + country,
        xaxis_title='Date',
        yaxis_title='No. of Confirmed Cases',
        margin=dict(l=20, r=20, t=40, b=20),
        paper_bgcolor="lightgrey",
        width = 800,
        
    );
    
    fig.update_yaxes(type="linear")
    fig.show();

Check the details of your country or the World

  • Enter the name of your country(in capitalized format(e.g. Italy)) and world for total cases
In [14]:
interact(plot_cases_of_a_country, country='World')

ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none' # uncomment this, run cell again - then the graph/figure disappears
widgets.VBox([fig], layout=ipywLayout)

10 worst hit countries - Confirmed cases

In [15]:
px.bar(
    sorted_country_df.head(10),
    x = "country",
    y = "confirmed",
    title= "Top 10 worst affected countries", # the axis names
    color_discrete_sequence=["#1D3461"], 
    height=500,
    width=800
)

10 worst hit countries - Death cases

In [16]:
px.bar(
    sorted_country_df.head(10),
    x = "country",
    y = "deaths",
    title= "Top 10 worst affected countries", # the axis names
    color_discrete_sequence=["#FF5964"], 
    height=500,
    width=800
)

Worst hit countries - Recovering cases

In [17]:
px.bar(
    sorted_country_df.head(10),
    x = "country",
    y = "recovered",
    title= "Top 10 worst affected countries", # the axis names
    color_discrete_sequence=["#1F487E"], 
    height=500,
    width=800
)

Global spread of COVID-19

In [18]:
import math
world_map = folium.Map(location=[11,0], tiles="cartodbpositron", zoom_start=2, max_zoom = 6, min_zoom = 2)


for i in range(0,len(confirmed_df)):
    if (-360<confirmed_df.iloc[i]['lat']<360 and -360<confirmed_df.iloc[i]['long']<360 ):
      folium.Circle(
        location=[confirmed_df.iloc[i]['lat'], confirmed_df.iloc[i]['long']],
        fill=True,
        radius=(int((np.log(confirmed_df.iloc[i,-1]+1.00001)))+0.2)*50000,
        color='#FF5964',
        fill_color='#FF5964',
        tooltip = "<div style='margin: 0; background-color: black; color: white;'>"+
                    "<h4 style='text-align:center;font-weight: bold'>"+confirmed_df.iloc[i]['country'] + "</h4>"
                    "<hr style='margin:10px;color: white;'>"+
                    "<ul style='color: white;;list-style-type:circle;align-item:left;padding-left:20px;padding-right:20px'>"+
                        "<li>Confirmed: "+str(confirmed_df.iloc[i,-1])+"</li>"+
                        "<li>Deaths:   "+str(death_df.iloc[i,-1])+"</li>"+
                        "<li>Death Rate: "+ str(np.round(death_df.iloc[i,-1]/(confirmed_df.iloc[i,-1]+1.00001)*100,2))+ "</li>"+
                    "</ul></div>",
        ).add_to(world_map)

world_map
Out[18]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [18]: